CREATE VIEW [dbo].[vCsOrderLines] AS SELECT
    Order_Lines.DESCRIPTION AS Description,
    Order_Lines.DISCOUNT AS Discount,
    Order_Lines.EXTENDED_AMOUNT AS ExtendedAmount,
    Order_Lines.EXTENDED_COST AS ExtendedCost,
    Order_Lines.INCOME_ACCOUNT AS IncomeAccount,
    Order_Lines.LINE_NUMBER AS LineNumber,
    Order_Lines.LOCATION AS Location,
    Order_Lines.NOTE AS Note,
    Order_Lines.ORDER_NUMBER AS OrderNumber,
    Order_Lines.PRODUCT_CODE AS ProductCode,
    Order_Lines.QUANTITY_BACKORDERED AS QuantityBackordered,
    Order_Lines.QUANTITY_COMMITTED AS QuantityCommitted,
    Order_Lines.QUANTITY_ORDERED AS QuantityOrdered,
    Order_Lines.QUANTITY_RESERVED AS QuantityReserved,
    Order_Lines.QUANTITY_SHIPPED AS QuantityShipped,
    Order_Lines.TAX_1 AS Tax1,
    Order_Lines.TAX_AUTHORITY AS VATTaxAuthority,
    Order_Lines.TAX_RATE AS VATTaxRate,
    Order_Lines.TAXABLE AS Taxable,
    Order_Lines.TAXABLE_2 AS GSTTaxable,
    Order_Lines.UNIT_COST AS UnitCost,
    Order_Lines.UNIT_PRICE AS UnitPrice
FROM Order_Lines
    INNER JOIN Orders
        ON Order_Lines.ORDER_NUMBER = Orders.ORDER_NUMBER
WHERE Orders.ORDER_TYPE_CODE IN ('FULL', 'REG')

GO